SELECT * FROM(
SELECT "temp_zc_info"."ts" FROM "temp_zc_info"
ORDER BY "temp_zc_info"."ts" DESC
)WHERE ROWNUM = 1